---
title: "SQL-005: Association type code lookup"
summary: Retrieve association type code definitions.
status: draft
owner: SAIF Corporation
last_reviewed: 2026-08-21
library: SAIF.Business.View.Policy
reference_type: embedded
---

# SQL-005 Association type code lookup

Retrieve association type code definitions.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-005 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAssociationTypeCodeCollection` |
| **Criteria property** | `RetrieveSQL` (delegates to `clsAssociationTypeCode.Criteria.Retrieve_SQL`) |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ASSOCIATION_TYPE_CODE](../database-tables.md#association_type_code) | SELECT | `CODE`, `CODE_DESCR`, `ASSOCIATION_TYPE_CATEGORY_CODE`, `SOURCE_PROCEDURE_NAME`, `SECURITY_GROUP_NAME`, `SORT_ORDER`, `POLICY_HEADER_DEFAULT_FLAG` |

## Sample SQL

```sql
SELECT
  ASSOCIATION_TYPE_CODE.CODE AS Code,
  ASSOCIATION_TYPE_CODE.CODE_DESCR AS Description,
  ASSOCIATION_TYPE_CODE.ASSOCIATION_TYPE_CATEGORY_CODE AS AssociationTypeCategoryCode,
  ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME AS SourceProcedureName,
  ASSOCIATION_TYPE_CODE.SECURITY_GROUP_NAME AS SecurityGroupName,
  ASSOCIATION_TYPE_CODE.SORT_ORDER AS SortOrder,
  ASSOCIATION_TYPE_CODE.POLICY_HEADER_DEFAULT_FLAG AS PolicyHeaderDefaultFlag
FROM ASSOCIATION_TYPE_CODE
```


## Operations and processes
- [Retrieve policy associations](../operations-processes.md)

## Business rules
- [BR-VP-020: Association type is secured when security group set](../business-rules.md#br-vp-020-association-type-is-secured-when-security-group-set)
- [BR-VP-021: Association category prefix classification](../business-rules.md#br-vp-021-association-category-prefix-classification)
- [BR-VP-027: Create/Insert/Update/Delete SQL are invalid](../business-rules.md#br-vp-027-createinsertupdatedelete-sql-are-invalid)

## Sources
- `SAIF.Business.View.Policy/Associations/clsAssociationTypeCodeCollection.vb`
- `SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb`